BEGIN;

CREATE TABLE contact_person (
    id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	object_state VARCHAR(30) NOT NULL,
	sid VARCHAR(32) NOT NULL,
	first_name VARCHAR(25) NOT NULL,
	last_name VARCHAR(35) NOT NULL,
	phone VARCHAR(9),
	email VARCHAR(35),
	school_id INT(11) NOT NULL,
	FOREIGN KEY (school_id) REFERENCES school(id) ON DELETE CASCADE,
	UNIQUE (sid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

COMMIT;